[dbo].[Product

Property	Value
Created	3:13:06 PM Friday, January 07, 2011
Last Modified	11:40:06 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key PK_Product_Price: PRODUCT_CODE\RULE_TYPE\CUSTOMER_TYPE$	RULE_TYPE	varchar(2)	2	('')
	PROD_TYPE	varchar(5)	5	('')
$Cluster Primary Key PK_Product_Price: PRODUCT_CODE\RULE_TYPE\CUSTOMER_TYPE$	PRODUCT_CODE	varchar(31)	31	('')
$Cluster Primary Key PK_Product_Price: PRODUCT_CODE\RULE_TYPE\CUSTOMER_TYPE$	CUSTOMER_TYPE	varchar(11)	11	('')
	CUSTOMER_ID	varchar(10)	10	('')
	BEGIN_DATE	datetime	8
	END_DATE	datetime	8
	RULE_KEY	varchar(50)	50	('')
	RATE_1	money	8	((0))
	RATE_2	money	8	((0))
	RATE_3	money	8	((0))
	RATE_4	money	8	((0))
	RATE_5	money	8	((0))
	RATE_6	money	8	((0))
	RATE_7	money	8	((0))
	RATE_8	money	8	((0))
	RATE_9	money	8	((0))
	RATE_10	money	8	((0))
	RATE_11	money	8	((0))
	RATE_12	money	8	((0))
	RATE_13	money	8	((0))
	RATE_14	money	8	((0))
	RATE_15	money	8	((0))
	RATE_16	money	8	((0))
	RATE_17	money	8	((0))
	RATE_18	money	8	((0))
	RATE_19	money	8	((0))
	RATE_20	money	8	((0))
	STEP_1	varchar(15)	15	('')
	STEP_2	varchar(15)	15	('')
	STEP_3	varchar(15)	15	('')
	STEP_4	varchar(15)	15	('')
	STEP_5	varchar(15)	15	('')
	STEP_6	varchar(15)	15	('')
	STEP_7	varchar(15)	15	('')
	STEP_8	varchar(15)	15	('')
	STEP_9	varchar(15)	15	('')
	STEP_10	varchar(15)	15	('')
	STEP_11	varchar(15)	15	('')
	STEP_12	varchar(15)	15	('')
	STEP_13	varchar(15)	15	('')
	STEP_14	varchar(15)	15	('')
	STEP_15	varchar(15)	15	('')
	STEP_16	varchar(15)	15	('')
	STEP_17	varchar(15)	15	('')
	STEP_18	varchar(15)	15	('')
	STEP_19	varchar(15)	15	('')
	STEP_20	varchar(15)	15	('')
	BASE_1	varchar(255)	255	('')
	BASE_2	varchar(255)	255	('')
	BASE_3	varchar(255)	255	('')
	BASE_4	varchar(255)	255	('')
	BASE_5	varchar(255)	255	('')
	BASE_6	varchar(255)	255	('')
	BASE_7	varchar(255)	255	('')
	BASE_8	varchar(255)	255	('')
	BASE_9	varchar(255)	255	('')
	BASE_10	varchar(255)	255	('')
	BASE_11	varchar(255)	255	('')
	BASE_12	varchar(255)	255	('')
	BASE_13	varchar(255)	255	('')
	BASE_14	varchar(255)	255	('')
	BASE_15	varchar(255)	255	('')
	BASE_16	varchar(255)	255	('')
	BASE_17	varchar(255)	255	('')
	BASE_18	varchar(255)	255	('')
	BASE_19	varchar(255)	255	('')
	BASE_20	varchar(255)	255	('')
	COMPLIMENTARY	bit	1	((0))
	INCOME_ACCOUNT	varchar(50)	50	('')
	FIELD_TYPE	tinyint	1	((0))
	SOURCE_FIELD	text	max
	STEPS_IN_USE	tinyint	1	((0))
	DESCRIPTION	varchar(40)	40	('')
	DEFERRED_INCOME_ACCOUNT	varchar(50)	50	('')
	BASE_TYPE	tinyint	1	((0))
	PRCNT_1	numeric(15,5)	9	((0))
	PRCNT_2	numeric(15,5)	9	((0))
	PRCNT_3	numeric(15,5)	9	((0))
	PRCNT_4	numeric(15,5)	9	((0))
	PRCNT_5	numeric(15,5)	9	((0))
	PRCNT_6	numeric(15,5)	9	((0))
	PRCNT_7	numeric(15,5)	9	((0))
	PRCNT_8	numeric(15,5)	9	((0))
	PRCNT_9	numeric(15,5)	9	((0))
	PRCNT_10	numeric(15,5)	9	((0))
	PRCNT_11	numeric(15,5)	9	((0))
	PRCNT_12	numeric(15,5)	9	((0))
	PRCNT_13	numeric(15,5)	9	((0))
	PRCNT_14	numeric(15,5)	9	((0))
	PRCNT_15	numeric(15,5)	9	((0))
	PRCNT_16	numeric(15,5)	9	((0))
	PRCNT_17	numeric(15,5)	9	((0))
	PRCNT_18	numeric(15,5)	9	((0))
	PRCNT_19	numeric(15,5)	9	((0))
	PRCNT_20	numeric(15,5)	9	((0))
	TIME_STAMP	timestamp	8

	Name	Columns	Unique
$Cluster Primary Key PK_Product_Price: PRODUCT_CODE\RULE_TYPE\CUSTOMER_TYPE$	PK_Product_Price	PRODUCT_CODE, RULE_TYPE, CUSTOMER_TYPE
	iProduct_PriceRULE_KEY	RULE_KEY

Type	Action	Owning Principal
Grant	Delete	IMIS
Grant	Insert	IMIS
Grant	References	IMIS
Grant	Select	IMIS
Grant	Update	IMIS

SQL Script

CREATE TABLE [dbo].[Product_Price]
(
[RULE_TYPE] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_RULE_TYPE] DEFAULT (''),
[PROD_TYPE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_PROD_TYPE] DEFAULT (''),
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_PRODUCT_CODE] DEFAULT (''),
[CUSTOMER_TYPE] [varchar] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_CUSTOMER_TYPE] DEFAULT (''),
[CUSTOMER_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_CUSTOMER_ID] DEFAULT (''),
[BEGIN_DATE] [datetime] NULL,
[END_DATE] [datetime] NULL,
[RULE_KEY] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_RULE_KEY] DEFAULT (''),
[RATE_1] [money] NOT NULL CONSTRAINT [DF_Product_Price_RATE_1] DEFAULT ((0)),
[RATE_2] [money] NOT NULL CONSTRAINT [DF_Product_Price_RATE_2] DEFAULT ((0)),
[RATE_3] [money] NOT NULL CONSTRAINT [DF_Product_Price_RATE_3] DEFAULT ((0)),
[RATE_4] [money] NOT NULL CONSTRAINT [DF_Product_Price_RATE_4] DEFAULT ((0)),
[RATE_5] [money] NOT NULL CONSTRAINT [DF_Product_Price_RATE_5] DEFAULT ((0)),
[RATE_6] [money] NOT NULL CONSTRAINT [DF_Product_Price_RATE_6] DEFAULT ((0)),
[RATE_7] [money] NOT NULL CONSTRAINT [DF_Product_Price_RATE_7] DEFAULT ((0)),
[RATE_8] [money] NOT NULL CONSTRAINT [DF_Product_Price_RATE_8] DEFAULT ((0)),
[RATE_9] [money] NOT NULL CONSTRAINT [DF_Product_Price_RATE_9] DEFAULT ((0)),
[RATE_10] [money] NOT NULL CONSTRAINT [DF_Product_Price_RATE_10] DEFAULT ((0)),
[RATE_11] [money] NOT NULL CONSTRAINT [DF_Product_Price_RATE_11] DEFAULT ((0)),
[RATE_12] [money] NOT NULL CONSTRAINT [DF_Product_Price_RATE_12] DEFAULT ((0)),
[RATE_13] [money] NOT NULL CONSTRAINT [DF_Product_Price_RATE_13] DEFAULT ((0)),
[RATE_14] [money] NOT NULL CONSTRAINT [DF_Product_Price_RATE_14] DEFAULT ((0)),
[RATE_15] [money] NOT NULL CONSTRAINT [DF_Product_Price_RATE_15] DEFAULT ((0)),
[RATE_16] [money] NOT NULL CONSTRAINT [DF_Product_Price_RATE_16] DEFAULT ((0)),
[RATE_17] [money] NOT NULL CONSTRAINT [DF_Product_Price_RATE_17] DEFAULT ((0)),
[RATE_18] [money] NOT NULL CONSTRAINT [DF_Product_Price_RATE_18] DEFAULT ((0)),
[RATE_19] [money] NOT NULL CONSTRAINT [DF_Product_Price_RATE_19] DEFAULT ((0)),
[RATE_20] [money] NOT NULL CONSTRAINT [DF_Product_Price_RATE_20] DEFAULT ((0)),
[STEP_1] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_STEP_1] DEFAULT (''),
[STEP_2] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_STEP_2] DEFAULT (''),
[STEP_3] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_STEP_3] DEFAULT (''),
[STEP_4] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_STEP_4] DEFAULT (''),
[STEP_5] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_STEP_5] DEFAULT (''),
[STEP_6] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_STEP_6] DEFAULT (''),
[STEP_7] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_STEP_7] DEFAULT (''),
[STEP_8] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_STEP_8] DEFAULT (''),
[STEP_9] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_STEP_9] DEFAULT (''),
[STEP_10] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_STEP_10] DEFAULT (''),
[STEP_11] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_STEP_11] DEFAULT (''),
[STEP_12] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_STEP_12] DEFAULT (''),
[STEP_13] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_STEP_13] DEFAULT (''),
[STEP_14] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_STEP_14] DEFAULT (''),
[STEP_15] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_STEP_15] DEFAULT (''),
[STEP_16] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_STEP_16] DEFAULT (''),
[STEP_17] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_STEP_17] DEFAULT (''),
[STEP_18] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_STEP_18] DEFAULT (''),
[STEP_19] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_STEP_19] DEFAULT (''),
[STEP_20] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_STEP_20] DEFAULT (''),
[BASE_1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_BASE_1] DEFAULT (''),
[BASE_2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_BASE_2] DEFAULT (''),
[BASE_3] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_BASE_3] DEFAULT (''),
[BASE_4] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_BASE_4] DEFAULT (''),
[BASE_5] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_BASE_5] DEFAULT (''),
[BASE_6] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_BASE_6] DEFAULT (''),
[BASE_7] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_BASE_7] DEFAULT (''),
[BASE_8] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_BASE_8] DEFAULT (''),
[BASE_9] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_BASE_9] DEFAULT (''),
[BASE_10] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_BASE_10] DEFAULT (''),
[BASE_11] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_BASE_11] DEFAULT (''),
[BASE_12] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_BASE_12] DEFAULT (''),
[BASE_13] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_BASE_13] DEFAULT (''),
[BASE_14] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_BASE_14] DEFAULT (''),
[BASE_15] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_BASE_15] DEFAULT (''),
[BASE_16] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_BASE_16] DEFAULT (''),
[BASE_17] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_BASE_17] DEFAULT (''),
[BASE_18] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_BASE_18] DEFAULT (''),
[BASE_19] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_BASE_19] DEFAULT (''),
[BASE_20] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_BASE_20] DEFAULT (''),
[COMPLIMENTARY] [bit] NOT NULL CONSTRAINT [DF_Product_Price_COMPLIMENTARY] DEFAULT ((0)),
[INCOME_ACCOUNT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_INCOME_ACCOUNT] DEFAULT (''),
[FIELD_TYPE] [tinyint] NOT NULL CONSTRAINT [DF_Product_Price_FIELD_TYPE] DEFAULT ((0)),
[SOURCE_FIELD] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[STEPS_IN_USE] [tinyint] NOT NULL CONSTRAINT [DF_Product_Price_STEPS_IN_USE] DEFAULT ((0)),
[DESCRIPTION] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_DESCRIPTION] DEFAULT (''),
[DEFERRED_INCOME_ACCOUNT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Price_DEFERRED_INCOME_ACCOUNT] DEFAULT (''),
[BASE_TYPE] [tinyint] NOT NULL CONSTRAINT [DF_Product_Price_BASE_TYPE] DEFAULT ((0)),
[PRCNT_1] [numeric] (15, 5) NOT NULL CONSTRAINT [DF_Product_Price_PRCNT_1] DEFAULT ((0)),
[PRCNT_2] [numeric] (15, 5) NOT NULL CONSTRAINT [DF_Product_Price_PRCNT_2] DEFAULT ((0)),
[PRCNT_3] [numeric] (15, 5) NOT NULL CONSTRAINT [DF_Product_Price_PRCNT_3] DEFAULT ((0)),
[PRCNT_4] [numeric] (15, 5) NOT NULL CONSTRAINT [DF_Product_Price_PRCNT_4] DEFAULT ((0)),
[PRCNT_5] [numeric] (15, 5) NOT NULL CONSTRAINT [DF_Product_Price_PRCNT_5] DEFAULT ((0)),
[PRCNT_6] [numeric] (15, 5) NOT NULL CONSTRAINT [DF_Product_Price_PRCNT_6] DEFAULT ((0)),
[PRCNT_7] [numeric] (15, 5) NOT NULL CONSTRAINT [DF_Product_Price_PRCNT_7] DEFAULT ((0)),
[PRCNT_8] [numeric] (15, 5) NOT NULL CONSTRAINT [DF_Product_Price_PRCNT_8] DEFAULT ((0)),
[PRCNT_9] [numeric] (15, 5) NOT NULL CONSTRAINT [DF_Product_Price_PRCNT_9] DEFAULT ((0)),
[PRCNT_10] [numeric] (15, 5) NOT NULL CONSTRAINT [DF_Product_Price_PRCNT_10] DEFAULT ((0)),
[PRCNT_11] [numeric] (15, 5) NOT NULL CONSTRAINT [DF_Product_Price_PRCNT_11] DEFAULT ((0)),
[PRCNT_12] [numeric] (15, 5) NOT NULL CONSTRAINT [DF_Product_Price_PRCNT_12] DEFAULT ((0)),
[PRCNT_13] [numeric] (15, 5) NOT NULL CONSTRAINT [DF_Product_Price_PRCNT_13] DEFAULT ((0)),
[PRCNT_14] [numeric] (15, 5) NOT NULL CONSTRAINT [DF_Product_Price_PRCNT_14] DEFAULT ((0)),
[PRCNT_15] [numeric] (15, 5) NOT NULL CONSTRAINT [DF_Product_Price_PRCNT_15] DEFAULT ((0)),
[PRCNT_16] [numeric] (15, 5) NOT NULL CONSTRAINT [DF_Product_Price_PRCNT_16] DEFAULT ((0)),
[PRCNT_17] [numeric] (15, 5) NOT NULL CONSTRAINT [DF_Product_Price_PRCNT_17] DEFAULT ((0)),
[PRCNT_18] [numeric] (15, 5) NOT NULL CONSTRAINT [DF_Product_Price_PRCNT_18] DEFAULT ((0)),
[PRCNT_19] [numeric] (15, 5) NOT NULL CONSTRAINT [DF_Product_Price_PRCNT_19] DEFAULT ((0)),
[PRCNT_20] [numeric] (15, 5) NOT NULL CONSTRAINT [DF_Product_Price_PRCNT_20] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[Product_Price] ADD CONSTRAINT [PK_Product_Price] PRIMARY KEY CLUSTERED ([PRODUCT_CODE], [RULE_TYPE], [CUSTOMER_TYPE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iProduct_PriceRULE_KEY] ON [dbo].[Product_Price] ([RULE_KEY]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Product_Price] TO [IMIS]
GRANT SELECT ON  [dbo].[Product_Price] TO [IMIS]
GRANT INSERT ON  [dbo].[Product_Price] TO [IMIS]
GRANT DELETE ON  [dbo].[Product_Price] TO [IMIS]
GRANT UPDATE ON  [dbo].[Product_Price] TO [IMIS]
GO